Executive Summary and Troubles That occurred During The Project
4

Troubles That Occurred During The Project
- CSV Source file columns name included space, modified those and removed spaces, including Camel Casing to rename those column names then converted source file to JSON .This resolved issue in Script Component Transformation Output Columns.
- Column Zip data type was number in source and it included Null values, used int datatype first time so in execution , package failed. Resolve this by changing output column data type in script task to string datatype instead of int datatype.

DESIGNING DATA WAREHOUSES TO SUPPORT CRIMINAL INVESTIGATION